New in Python.
I am trying to convert JSON files to SQL files, but JSON file it's to complex with many entries, the structure it's like this:
['{"category": "new", "id": 1, "Name": ["Tester1"], "properties": {"host": "xxx", "type": "yyy", "device": null, "serial": "ddddd", "manufacturer": "vvvv"}}\n,']
... next entry....
I have a list, my final objective is to get something like this t then import with SQL commands:
Columns: category | id | Name | host| type | device | serial |manufacturer
Attributes: new | 1 | Tester1 | xxxx | yyy | null | dddd| yyyy
Any ideas to start?
Thank you.